package com.iursp.mapper.role;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.iursp.domain.model.role.AuthInterface;

import tk.mybatis.mapper.common.BaseMapper;

@Mapper
public interface AuthInterfaceMapper extends BaseMapper<AuthInterface>{
	
	
	@Select("SELECT * FROM auth_plat_interface apLf LEFT JOIN auth_interface aIF on apLf.interface_refid = aIF.refid\r\n" + 
			"WHERE app_id = #{app_id} AND app_secret=#{app_secret}")
	List<AuthInterface> selectByPrimaryAppSecret(@Param("app_id")String app_id, @Param("app_secret")String app_secret);

}
